Creating a Selection Set from a Query

You create a dynamic selection set by creating a query-based selection set. A query-based selection set can contain one or more queries, which are valid SQL expressions.

To create a new selection set from a query:

In the Selection Sets Manager, click the New button and select Create from Query. The Selection by Query dialog box appears.
Available queries appear in the list pane on the left; queries selected to be part of the selection set appear in the list pane on the right. Use the arrow buttons in the middle of the dialog to add one or all queries from the Available Queries list to the Selected Queries list, or to remove queries from the Selected list.
You can also double-click queries on either side of the dialog box to add them to or remove them from the selection set.

Selection by Query Dialog Box

The Selection by Query dialog box lets you create selection sets from available queries. The dialog box contains the following controls:

Available Queries	Contains all the queries that are available for your selection set. The Available Columns list is located on the left side of the dialog box.
Selected Queries	Contains queries that are part of the selection set. To add queries to the Selected Queries list, select one or more queries in the Available Queries list, then click the Add button [>].
Query Manipulation Buttons	Lets you select or clear queries to be used in the selection set: [ > ] Adds the selected items from the Available Queries list to the Selected Queries list. [ >> ] Adds all of the items in the Available Queries list to the Selected Queries list. [ < ] Removes the selected items from the Selected Queries list. [ << ] Removes all items from the Selected Queries list. Note: You can select multiple queries in the Available Queries list by holding down the Shift key or the Control key while clicking with the mouse. Holding down the Shift key provides group selection behavior. Holding down the Control key provides single element selection behavior.